<?php get_main_menu("receptionist") ?>
<?php
mysql_select_db($database_drycleaners_conn, $drycleaners_conn);
$query_get_order_item = "
SELECT suborder_item.id,
       item.name as item_name,
       material.name as material_name,
       order_item.color,
       type_of_service.name as type_of_service_name
  FROM    (   (   (   drycleaners.order_item order_item
                   INNER JOIN
                      drycleaners.material material
                   ON (order_item.material_id = material.id))
               INNER JOIN
                  drycleaners.suborder_item suborder_item
               ON (suborder_item.order_item_id = order_item.id))
           INNER JOIN
              drycleaners.item item
           ON (order_item.item_id = item.id))
       INNER JOIN
          drycleaners.type_of_service type_of_service
       ON (order_item.type_of_service_id = type_of_service.id)
Where suborder_item.suborder_id='".$_REQUEST['suborder_id']."'
";
$get_order_item = mysql_query($query_get_order_item, $drycleaners_conn) or die(mysql_error());
$row_get_order_item = mysql_fetch_assoc($get_order_item);
$totalRows_get_order_item = mysql_num_rows($get_order_item);
?>
<?php include"includes/table_settings.php"?>
  <a href="<?php echo "?".$_REQUEST['back_page']?>&order_id=<?php echo $_REQUEST['order_id']?>"><img src="images/back-button.png" width="30" height="30" title="Back" /></a></div> 
              <table cellpadding="0" cellspacing="0" border="0" id="dataTable">
                <thead>
                  <tr>
                    <th>Id</th>
                    <th>Item</th>
                    <th>Material</th>
                    <th>Color</th>
                    <th>Type Of Service</th>
                  </tr>
                </thead>
                <tbody>
                  <!--Loop start, you could use a repeat region here-->
  <?php do{?>
    <!--Loop start, you could use a repeat region here-->
    <tr>
      <td><?php echo $row_get_order_item['id']?></td>
      <td><?php echo $row_get_order_item['item_name']?></td>
      <td><?php echo $row_get_order_item['material_name']?></td>
      <td><?php echo $row_get_order_item['color']?></td>
      <td><?php echo $row_get_order_item['type_of_service_name']?></td>
    </tr>
    <?php }while($row_get_order_item=mysql_fetch_assoc($get_order_item));?>
                  <!--Loop end-->
                </tbody>
              </table>
        	</div>
<div class="tab_column" id="form_area">
          </div>         
     	</div>     
</div>
<?php
mysql_free_result($get_order_item);
?>